package com.cms.constant;

public interface ReportConstant {
	

	public static final String QUERY_CMS_SEQ="SELECT NEXTVAL(:catalog)as cmsOrder";
	
	public static final String QUERY_SYS_CONFIG="select fn_getCmsConfig(:key)as value";
	
	public static final String QUERY_CMS_PARAM ="catalog";
	
    public static final String CMS_ORDER_KEY="cmsOrder";
    
	public static final String QUERY_SYS_PARAM ="key";
	
    public static final String CMS_SYS_KEY="value";
    
    public static final String STATISTICS_TYPE_MONTH="month";
    
    public static final String STATISTICS_TYPE_DAY="day";
    
    //需要缓存的数据                                                                              
    public static final String REPORT_CACHE_SQL="SELECT REP_HEADER,REP_QUERY,REP_BODY,REP_FOOT,REP_SUMMARY,REP_CODE,REP_NAME,REP_SQL,REP_HANDLER,CACHE_HANDLER FROM TR_REP_CONF where REP_CODE=:REP_CODE LIMIT 1";
    
    public static final String REPORT_REP_SQL="REP_SQL";
    
    public static final String REPORT_REP_HANDLER="REP_HANDLER";
    
    public static final String REPORT_CACHE_HANDLER="CACHE_HANDLER";
}
